SUPPORT / SAMPLES & SAS NOTES
Problem Note 41487: Duplication message appears in Microsoft Excel when sorting data items in an information map opened using the SAS® Add-In for Microsoft Office
 |  |  |  |
When sorting data items in an information map, you might see the following error in Microsoft Excel.
The item xxxx is already selected as a sort item
This message appears if you attempt to re-use a data item that has been selected and then removed from sorting. For example, on the Sort tab in the Open Information Map dialog box, you select Country as the second sort item, but then you remove it from the sort. If you attempt to select Country again, you will see the error.
As a workaround, if you need to re-use a data item that has been selected and then removed from sorting, click the Clear All button and re-specify all of your sort selections.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.2 | 5.1 | 9.2 TS2M0 | 9.3 TS1M0 | ||